NetWare SQL NetWare SQL is Novell's high-performance relational database engine designed specifically for the NetWare operating environment. NetWare SQL takes full advantage of the NetWare operating system, adding the rigorous security and integrity features of SQL (Structured Query Language) to the proven reliability of NetWare. NetWare and NetWare SQL provide the complete foundation for network database computing. When combined with a wide range of database applications such as spreadsheets, accounting packages, fourth-generation programming languages (4GL), and other database managers, you have a complete network or distributed database solution. Additionally, custom applications may be developed easily using XQL, Novell's developer's kit for NetWare SQL. Optimized network performance With NetWare SQL, distributed application processing on a network is provided through client-server architecture. In this architecture, "client" applications have their database access and management performed by the "server" database engine. This eliminates the need for moving entire files from the server to the workstation for processing. Since NetWare SQL performs most of the data management processing at the server, only requested information is returned to the workstation, greatly enhancing concurrency and reducing network traffic. NetWare SQL can simultaneously process multiple requests from different applications. Centralized security and integrity NetWare SQL manages data security and integrity centrally at the NetWare server rather than at multiple workstations around the LAN. Data management tasks such as record-locking and security control are thus enhanced through NetWare SQL's centralized control. Also, data integrity and recovery are established through NetWare's Transaction Tracking System (TTS). Multiple server access with location transparency NetWare SQL allows you to partition your data across multiple servers according to the requirements of your application. The physical location of the data is transparent to an application program, allowing it to perform relational "joins" across multiple NetWare SQL servers. For example, one server could be installed in Accounting and one in Sales, and yet someone from Marketing could generate reports using data from both. Improved use of workstation resources Since all query processing is performed by NetWare SQL, the workstation is concerned only with the front end application and a NetWare SQL requester program. This frees memory space in the workstation and lets you run larger, more powerful client applications. NetWare SQL requester programs accept requests from front end applications and transmit these requests to the server for processing. NetWare SQL requesters are available for workstations in the DOS, OS/2, and Windows operating environments. Industry-standard, open application program interface XQL is Novell's developer's kit for NetWare SQL (sold separately). XQL provides you access through three programming levels: ANSI/ISO standard SQL statements, stored SQL statements, Embedded SQL in the C programming language, and Novell SQL extensions. Language interfaces are provided for C, BASIC, Pascal, and COBOL. High-performance record management NetWare SQL utilizes NetWare Btrieve, Novell's key-indexed record management system that supports high-performance file handling and improves programming productivity. This means that NetWare SQL applications can share files created and maintained by the numerous Btrieve applications. Hardware/Memory Requirements NetWare SQL runs in any NetWare server with at least 4MB (Value Added Process version) or 5MB (NetWare Loadable Module version) of RAM. The NetWare SQL Requesters are identical for the VAP and NLM versions of NetWare SQL. The DOS Requester uses approximately 70KB of RAM. Actual use depends on your selection of NetWare SQL parameters. DOS Requesters run with DOS v3.1 or above. The OS/2 Requester and the Windows Requester use approximately 90KB of RAM. Actual use depends on your selection of NetWare SQL parameters. OS/2 Requesters run with OS/2 Standard and Extended Editions 1.1. Windows Requesters run with Windows v3.0 and above. Software Requirements At the server, NetWare SQL requires Advanced or SFT NetWare, version 2.1 or above, and NetWare Btrieve, version 5.10 or above. NetWare SQL 386 requires NetWare v3.x or above, and NetWare Btrieve 386 v5.10 or above. Applications can be created to support DOS, OS/2 and Windows workstation environments. Novell, NetWare, XQL, and Btrieve are registered trademarks of Novell, Inc.. NetWare SQL and NetWare Loadable Module are trademarks of Novell, Inc.. Other computer and software names are registered trademarks or trademarks of their respective manufacturers. For more information To obtain NetWare SQL and/or XQL, contact your local Novell representative. For additional product information, and a comprehensive list of third-party NetWare SQL front-end applications, call Novell Technical Marketing Support, (800) RED-WORD (800-733-9673). Outside the United States and Canada, call (512) 794-1796 or your nearest Novell office. FAX (512) 345-7478.